package com.foreveredu.propms.persist;

import java.util.List;
import java.util.Map;

import com.foreveredu.propms.domain.PageModel;
import com.foreveredu.propms.domain.SubDistrict;

public interface ISubDistrictDao extends IDao<SubDistrict, Integer> {

	List<SubDistrict> findSubDistrictsOfDistrict(int districtId);
	
	SubDistrict findSubDistrictsOfSubDistrictId(String subDistrictId);

	//查询当前小区某年某月的物业费收缴率(已缴费房产数/总房产数)
	Map<String, Object> querySubPaidRate(SubDistrict sub, int year, int month);

	//查询当前小区某年某月的物业费收费汇总
	Map<String, Object> querySubMonthlyCharge(SubDistrict sub, int year, int month);
	
	//查询当前小区某年的物业费收费汇总
	Map<String, Object> querySubMonthlyChargeYear(SubDistrict sub, int year);
	
	//根据小区处查询所有用户缴费明细
	public PageModel queryUserBySub(SubDistrict sub, int year, int month,int offset);
	

	//根据小区处查询所有用户缴费明细导出到Excel中
	public List<Map<String, Object>> doQueryownerChargeToExcel(SubDistrict sub,
			int year, int month);

	//查询收费项明细

	public PageModel queryIndividualCharge(SubDistrict sub, int year, int month,int offset,int chargeItemId);

	
	//将查询出的结果导入到Excel中
	List<Map<String, Object>> queryIndividualChargeIntoExcel(SubDistrict sub, int year, int month,int chargeItemId);

}


